###############################################################################   
#### Replication Materials                                                 #### 
#### Kim, Nakka, Gopal, Desmrais, Mancinelli, Harden, Ko, Boehmke. 2021.   ####
#### Attention to the COVID-19 pandemic on Twitter:                        ####
#### Partisan differences among U.S. state legislators                     ####
#### Legislative Studies Quarterly                                         ####
###############################################################################  


###############################################################################
################################### Set Up ####################################
###############################################################################

# packages -------------------------

lapply(c('readr', 'stargazer', 'texreg', 'xtable', 'lme4', 'glmmTMB','plm',
  'lmtest', 'interplot','dummies','effects', 'ggthemes','caret', 
  'ggeffects', 'scales','ggrepel','sandwich','reshape2'), 
  require, 
  character.only = TRUE)

# read data set for regression -------------------------

data_path <- '/Users/taegyoon/Google Drive/spap_state/spap_state_attention/data/' 
df <- read_csv(paste0(data_path, "spap_state_attention_regression.csv")) 
df <- subset(df, select = -c(X1))


###############################################################################
################# Table S6: Regression with Logged DV + 0.01 ##################
###############################################################################

# set the panel structure -------------------------

plm_df <- pdata.frame(x = df, 
                      index = c('user.screen_name', 'week'))

# fit models -------------------------

constant_state <- plm(covid_relevant_1_log_0.01 ~ 
                    state_case_pop + 
                    state_death_pop + 
                    state_covid_policy + 
                    party_new + 
                    state_abbrev + 
                    week_new + week_new_2 + week_new_3,
                  data = plm_df,
                  index = c('user.screen_name', 'week_new'),
                  model = 'random', 
                  effect = 'twoways')

constant_national <- plm(covid_relevant_1_log_0.01 ~ 
                       national_case_pop + 
                       national_death_pop + 
                       state_covid_policy + 
                       party_new + 
                       state_abbrev + 
                       week_new + week_new_2 + week_new_3,                                             
                     data = plm_df,
                     index = c('user.screen_name', 'week_new'),
                     model = 'random', 
                     effect = 'twoways')

constant_all <- plm(covid_relevant_1_log_0.01 ~ 
                  state_case_pop + 
                  state_death_pop +
                  national_case_pop + 
                  national_death_pop +
                  state_covid_policy + 
                  party_new +
                  state_abbrev +
                  week_new + week_new_2 + week_new_3,            
                data = plm_df,
                index = c('user.screen_name', 'week_new'),
                model = 'random', 
                effect = 'twoways')

constant_state_inter <- plm(covid_relevant_1_log_0.01 ~ 
                          party_new*state_case_pop + 
                          party_new*state_death_pop +
                          party_new*state_covid_policy + 
                          state_abbrev +
                          week_new + week_new_2 + week_new_3,            
                        data = plm_df,
                        index = c('user.screen_name', 'week_new'),
                        model = 'random', 
                        effect = 'twoways')

constant_national_inter <- plm(covid_relevant_1_log_0.01 ~ 
                             party_new*national_case_pop + 
                             party_new*national_death_pop +
                             party_new*state_covid_policy + 
                             state_abbrev +
                             week_new + week_new_2 + week_new_3,            
                           data = plm_df,
                           index = c('user.screen_name', 'week_new'),
                           model = 'random', 
                           effect = 'twoways')

constant_all_inter <- plm(covid_relevant_1_log_0.01 ~ 
                        party_new*state_case_pop + 
                        party_new*state_death_pop +
                        party_new*national_case_pop + 
                        party_new*national_death_pop +
                        party_new*state_covid_policy + 
                        state_abbrev +
                        week_new + week_new_2 + week_new_3,            
                      data = plm_df,
                      index = c('user.screen_name', 'week_new'),
                      model = 'random', 
                      effect = 'twoways')

constant_all_inter_ctl <- plm(covid_relevant_1_log_0.01 ~ 
                            party_new*state_case_pop + 
                            party_new*state_death_pop +
                            party_new*national_case_pop + 
                            party_new*national_death_pop +
                            party_new*state_covid_policy + 
                            np_score +
                            major_cham +
                            state_abbrev +
                            week_new + week_new_2 + week_new_3,            
                          data = plm_df,
                          index = c('user.screen_name', 'week_new'),
                          model = 'random', 
                          effect = 'twoways')

# adjust SE for serial correlation -------------------------

constant_state_adj <- coeftest(constant_state, 
                           vcovHC(constant_state, 
                                  method = 'arellano'))

constant_national_adj <- coeftest(constant_national, 
                              vcovHC(constant_national, 
                                     method = 'arellano'))

constant_all_adj <- coeftest(constant_all, 
                         vcovHC(constant_all, 
                                method = 'arellano'))

constant_state_inter_adj <- coeftest(constant_state_inter, 
                                 vcovHC(constant_state_inter, 
                                        method = 'arellano'))

constant_national_inter_adj <- coeftest(constant_national_inter, 
                                    vcovHC(constant_national_inter, 
                                           method = 'arellano'))

constant_all_inter_adj <- coeftest(constant_all_inter, 
                               vcovHC(constant_all_inter, 
                                      method = 'arellano'))

constant_all_inter_ctl_adj <- coeftest(constant_all_inter_ctl, 
                                   vcovHC(constant_all_inter_ctl, 
                                          method = 'arellano'))


###############################################################################
######################## Generate Latex Code : Table S6 #######################
###############################################################################

# get information for the last six rows -------------------------

texreg(
  list(constant_state, constant_national, constant_all,
       constant_state_inter, constant_national_inter, constant_all_inter, 
       constant_all_inter_ctl),
  omit.coef = 'abbrev',
  digits = 5,
  caption = 'Panel Regression Model (State Fixed Effect and Legislator-week Random Effect): 
  Population Normalized + Three-fold Party Variable + Week Polynomial + Logged DV (0.01 added)',
  custom.coef.names = c('(Intercept)',
                        'State New Cases (per 10k)',
                        'State New Deaths (per 10k)',
                        'State COVID-19 Policies',
                        'Other',
                        'Republican',
                        'Week',
                        'Week (quadratic)',
                        'Week (cubic)',
                        'National New Cases (per 10k)',
                        'National New Deaths (per 10k)',
                        'Other * State New Cases (per 10k)',
                        'Republican * State New Cases (per 10k)',
                        'Other * State New Deaths (per 10k)',
                        'Republican * State New Deaths (per 10k)',
                        'Other * State COVID-19 Policies',
                        'Republican * State COVID-19 Policies',
                        'Other * National New Cases (per 10k)',
                        'Republican * National New Cases (per 10k)',
                        'Other * National New Deaths (per 10k)',
                        'Republican * National New Deaths (per 10k)',
                        'Legislator Ideology',
                        'Chamber Majority Status'
                        )
  )

# get information for betas and corresponding standard errors -------------------------

texreg(
  list(constant_state_adj, constant_national_adj, constant_all_adj,
       constant_state_inter_adj, constant_national_inter_adj, constant_all_inter_adj, 
       constant_all_inter_ctl_adj),
  omit.coef = 'abbrev',
  digits = 5,
  caption = 'Panel Regression Model (State Fixed Effect and Legislator-week Random Effect): 
  Population Normalized + Three-fold Party Variable + Week Polynomial + Logged DV (0.01 added)',
  custom.coef.names = c('(Intercept)',
                        'State New Cases (per 10k)',
                        'State New Deaths (per 10k)',
                        'State COVID-19 Policies',
                        'Other',
                        'Republican',
                        'Week',
                        'Week (quadratic)',
                        'Week (cubic)',
                        'National New Cases (per 10k)',
                        'National New Deaths (per 10k)',
                        'Other * State New Cases (per 10k)',
                        'Republican * State New Cases (per 10k)',
                        'Other * State New Deaths (per 10k)',
                        'Republican * State New Deaths (per 10k)',
                        'Other * State COVID-19 Policies',
                        'Republican * State COVID-19 Policies',
                        'Other * National New Cases (per 10k)',
                        'Republican * National New Cases (per 10k)',
                        'Other * National New Deaths (per 10k)',
                        'Republican * National New Deaths (per 10k)',
                        'Legislator Ideology',
                        'Chamber Majority Status'
                        )
  )
